 drop table jms_dwd.jms_dwd.wide_table_index partition;
 CREATE EXTERNAL TABLE jms_dwd.jms_dwd.wide_table_index partition(
   `data_base` string COMMENT '数据库名',
   `table_name` string COMMENT '宽表名',
   `today_number ` bigint COMMENT '今日数据条数',
   `compare_partition` string COMMENT '对比的数据分区',
   `same_ratio` string COMMENT '数据量环比',
   `prekey_ratio` string COMMENT '主键去重的数据量',
   `extend_t1` string COMMENT '备用字段'
   ) comment '签收轨迹概要表'
 PARTITIONED BY (
   `dt` string COMMENT '运单最早签收时间')
 STORED as parquet
  LOCATION
   '/dw/hive/jms_dwd.db/external/wide_table_index';

